package db;

import java.sql.*; 
public abstract class AbstractDAO {

	protected Connection conn;
	private static final String URL = "jdbc:oracle:thin:@//w4111c.cs.columbia.edu:1521/ADB"; 
	private static final String URL2 = "jdbc:oracle:thin:@//w4111b.cs.columbia.edu:1521/ADB";
	
	public AbstractDAO()
		throws ClassNotFoundException, SQLException
	{
		// Step 1: Load the JDBC driver. 
		Class.forName ("oracle.jdbc.driver.OracleDriver"); 
		// Step 2: Establish the connection to the database. 
		conn = DriverManager.getConnection(URL,"sgf2110","db123");  
	}
	
	public abstract AbstractDbResponse execute(AbstractDbRequest dbRequest);

}
